Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	8950
Missing cells	314
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.6 MiB
Average record size in memory	191.0 B

Variable types

Text	1
Numeric	17

Alerts

`BALANCE` is highly overall correlated with `BALANCE_FREQUENCY` and 4 other fields	High correlation
`BALANCE_FREQUENCY` is highly overall correlated with `BALANCE` and 1 other fields	High correlation
`CASH_ADVANCE` is highly overall correlated with `BALANCE` and 2 other fields	High correlation
`CASH_ADVANCE_FREQUENCY` is highly overall correlated with `BALANCE` and 2 other fields	High correlation
`CASH_ADVANCE_TRX` is highly overall correlated with `BALANCE` and 2 other fields	High correlation
`INSTALLMENTS_PURCHASES` is highly overall correlated with `PURCHASES` and 3 other fields	High correlation
`MINIMUM_PAYMENTS` is highly overall correlated with `BALANCE` and 1 other fields	High correlation
`ONEOFF_PURCHASES` is highly overall correlated with `ONEOFF_PURCHASES_FREQUENCY` and 2 other fields	High correlation
`ONEOFF_PURCHASES_FREQUENCY` is highly overall correlated with `ONEOFF_PURCHASES` and 2 other fields	High correlation
`PURCHASES` is highly overall correlated with `INSTALLMENTS_PURCHASES` and 5 other fields	High correlation
`PURCHASES_FREQUENCY` is highly overall correlated with `INSTALLMENTS_PURCHASES` and 3 other fields	High correlation
`PURCHASES_INSTALLMENTS_FREQUENCY` is highly overall correlated with `INSTALLMENTS_PURCHASES` and 3 other fields	High correlation
`PURCHASES_TRX` is highly overall correlated with `INSTALLMENTS_PURCHASES` and 5 other fields	High correlation
`MINIMUM_PAYMENTS` has 313 (3.5%) missing values	Missing
`CUST_ID` has unique values	Unique
`PURCHASES` has 2044 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES` has 4302 (48.1%) zeros	Zeros
`INSTALLMENTS_PURCHASES` has 3916 (43.8%) zeros	Zeros
`CASH_ADVANCE` has 4628 (51.7%) zeros	Zeros
`PURCHASES_FREQUENCY` has 2043 (22.8%) zeros	Zeros
`ONEOFF_PURCHASES_FREQUENCY` has 4302 (48.1%) zeros	Zeros
`PURCHASES_INSTALLMENTS_FREQUENCY` has 3915 (43.7%) zeros	Zeros
`CASH_ADVANCE_FREQUENCY` has 4628 (51.7%) zeros	Zeros
`CASH_ADVANCE_TRX` has 4628 (51.7%) zeros	Zeros
`PURCHASES_TRX` has 2044 (22.8%) zeros	Zeros
`PAYMENTS` has 240 (2.7%) zeros	Zeros
`PRC_FULL_PAYMENT` has 5903 (66.0%) zeros	Zeros

Reproduction

Analysis started	2024-08-01 19:43:24.514992
Analysis finished	2024-08-01 19:43:40.542154
Duration	16.03 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

CUST_ID
Text

UNIQUE

Distinct	8950
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	480.8 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	53700
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8950 ?
Unique (%)	100.0%

Sample

1st row	C10001
2nd row	C10002
3rd row	C10003
4th row	C10004
5th row	C10005

Value	Count	Frequency (%)
c10001	1	< 0.1%
c10011	1	< 0.1%
c10017	1	< 0.1%
c10016	1	< 0.1%
c10015	1	< 0.1%
c10014	1	< 0.1%
c10013	1	< 0.1%
c10012	1	< 0.1%
c10010	1	< 0.1%
c10034	1	< 0.1%
Other values (8940)	8940	99.9%

Most occurring characters

Value	Count	Frequency (%)
1	12672	23.6%
C	8950	16.7%
0	3737	7.0%
2	3652	6.8%
3	3651	6.8%
5	3642	6.8%
7	3640	6.8%
4	3636	6.8%
6	3633	6.8%
8	3633	6.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	53700	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	12672	23.6%
C	8950	16.7%
0	3737	7.0%
2	3652	6.8%
3	3651	6.8%
5	3642	6.8%
7	3640	6.8%
4	3636	6.8%
6	3633	6.8%
8	3633	6.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	53700	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	12672	23.6%
C	8950	16.7%
0	3737	7.0%
2	3652	6.8%
3	3651	6.8%
5	3642	6.8%
7	3640	6.8%
4	3636	6.8%
6	3633	6.8%
8	3633	6.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	53700	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	12672	23.6%
C	8950	16.7%
0	3737	7.0%
2	3652	6.8%
3	3651	6.8%
5	3642	6.8%
7	3640	6.8%
4	3636	6.8%
6	3633	6.8%
8	3633	6.8%

BALANCE
Real number (ℝ)

HIGH CORRELATION

Distinct	8871
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1564.4748

Minimum	0
Maximum	19043.139
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	8.8145184
Q1	128.28192
median	873.38523
Q3	2054.14
95-th percentile	5909.1118
Maximum	19043.139
Range	19043.139
Interquartile range (IQR)	1925.8581

Descriptive statistics

Standard deviation	2081.5319
Coefficient of variation (CV)	1.3304988
Kurtosis	7.6747513
Mean	1564.4748
Median Absolute Deviation (MAD)	799.8652
Skewness	2.393386
Sum	14002050
Variance	4332775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80	0.9%
40.900749	1	< 0.1%
1213.551338	1	< 0.1%
1253.188317	1	< 0.1%
5058.299635	1	< 0.1%
296.905944	1	< 0.1%
1084.652647	1	< 0.1%
237.198442	1	< 0.1%
1636.518315	1	< 0.1%
468.851415	1	< 0.1%
Other values (8861)	8861	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	80	0.9%
0.000199	1	< 0.1%
0.001146	1	< 0.1%
0.001214	1	< 0.1%
0.001289	1	< 0.1%
0.004816	1	< 0.1%
0.006651	1	< 0.1%
0.009684	1	< 0.1%
0.01968	1	< 0.1%
0.021102	1	< 0.1%

Value	Count	Frequency (%)
19043.13856	1	< 0.1%
18495.55855	1	< 0.1%
16304.88925	1	< 0.1%
16259.44857	1	< 0.1%
16115.5964	1	< 0.1%
15532.33972	1	< 0.1%
15258.2259	1	< 0.1%
15244.74865	1	< 0.1%
15155.53286	1	< 0.1%
14581.45914	1	< 0.1%

BALANCE_FREQUENCY
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.87727073

Minimum	0
Maximum	1
Zeros	80
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.272727
Q1	0.888889
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.111111

Descriptive statistics

Standard deviation	0.236904
Coefficient of variation (CV)	0.27004663
Kurtosis	3.0923696
Mean	0.87727073
Median Absolute Deviation (MAD)	0
Skewness	-2.0232655
Sum	7851.573
Variance	0.056123506
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.818182	278	3.1%
0.727273	223	2.5%
0.545455	219	2.4%
0.636364	209	2.3%
0.454545	172	1.9%
0.363636	170	1.9%
0.272727	151	1.7%
0.181818	146	1.6%
Other values (33)	761	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	80	0.9%
0.090909	67	0.7%
0.1	8	0.1%
0.111111	5	0.1%
0.125	9	0.1%
0.142857	7	0.1%
0.166667	7	0.1%
0.181818	146	1.6%
0.2	9	0.1%
0.222222	5	0.1%

Value	Count	Frequency (%)
1	6211	69.4%
0.909091	410	4.6%
0.9	55	0.6%
0.888889	53	0.6%
0.875	57	0.6%
0.857143	51	0.6%
0.833333	60	0.7%
0.818182	278	3.1%
0.8	20	0.2%
0.777778	22	0.2%

PURCHASES
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	6203
Distinct (%)	69.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1003.2048

Minimum	0
Maximum	49039.57
Zeros	2044
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39.635
median	361.28
Q3	1110.13
95-th percentile	3998.6195
Maximum	49039.57
Range	49039.57
Interquartile range (IQR)	1070.495

Descriptive statistics

Standard deviation	2136.6348
Coefficient of variation (CV)	2.1298091
Kurtosis	111.38877
Mean	1003.2048
Median Absolute Deviation (MAD)	361.28
Skewness	8.1442691
Sum	8978683.3
Variance	4565208.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
45.65	27	0.3%
60	16	0.2%
150	16	0.2%
300	13	0.1%
200	13	0.1%
100	13	0.1%
450	12	0.1%
50	10	0.1%
600	10	0.1%
Other values (6193)	6776	75.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2044	22.8%
0.01	4	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	2	< 0.1%
1.4	1	< 0.1%
2	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%

Value	Count	Frequency (%)
49039.57	1	< 0.1%
41050.4	1	< 0.1%
40040.71	1	< 0.1%
38902.71	1	< 0.1%
35131.16	1	< 0.1%
32539.78	1	< 0.1%
31299.35	1	< 0.1%
27957.68	1	< 0.1%
27790.42	1	< 0.1%
26784.62	1	< 0.1%

ONEOFF_PURCHASES
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4014
Distinct (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	592.43737

Minimum	0
Maximum	40761.25
Zeros	4302
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	38
Q3	577.405
95-th percentile	2671.094
Maximum	40761.25
Range	40761.25
Interquartile range (IQR)	577.405

Descriptive statistics

Standard deviation	1659.8879
Coefficient of variation (CV)	2.8017948
Kurtosis	164.18757
Mean	592.43737
Median Absolute Deviation (MAD)	38
Skewness	10.045083
Sum	5302314.5
Variance	2755227.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4302	48.1%
45.65	46	0.5%
50	17	0.2%
200	15	0.2%
60	13	0.1%
100	13	0.1%
150	12	0.1%
70	12	0.1%
1000	12	0.1%
250	11	0.1%
Other values (4004)	4497	50.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4302	48.1%
0.01	7	0.1%
0.02	2	< 0.1%
0.05	1	< 0.1%
0.24	1	< 0.1%
0.7	1	< 0.1%
1	4	< 0.1%
1.4	2	< 0.1%
2	1	< 0.1%
4.99	1	< 0.1%

Value	Count	Frequency (%)
40761.25	1	< 0.1%
40624.06	1	< 0.1%
34087.73	1	< 0.1%
33803.84	1	< 0.1%
26547.43	1	< 0.1%
26514.32	1	< 0.1%
25122.77	1	< 0.1%
24543.52	1	< 0.1%
23032.97	1	< 0.1%
22257.39	1	< 0.1%

INSTALLMENTS_PURCHASES
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4452
Distinct (%)	49.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	411.06764

Minimum	0
Maximum	22500
Zeros	3916
Zeros (%)	43.8%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	89
Q3	468.6375
95-th percentile	1750.0875
Maximum	22500
Range	22500
Interquartile range (IQR)	468.6375

Descriptive statistics

Standard deviation	904.33812
Coefficient of variation (CV)	2.199974
Kurtosis	96.575178
Mean	411.06764
Median Absolute Deviation (MAD)	89
Skewness	7.2991199
Sum	3679055.4
Variance	817827.43
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3916	43.8%
300	14	0.2%
200	14	0.2%
100	14	0.2%
150	12	0.1%
125	11	0.1%
75	9	0.1%
350	8	0.1%
450	8	0.1%
500	8	0.1%
Other values (4442)	4936	55.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3916	43.8%
1.95	1	< 0.1%
4.44	1	< 0.1%
4.8	1	< 0.1%
6.33	1	< 0.1%
7.26	1	< 0.1%
7.67	1	< 0.1%
9.28	1	< 0.1%
9.58	1	< 0.1%
9.65	1	< 0.1%

Value	Count	Frequency (%)
22500	1	< 0.1%
15497.19	1	< 0.1%
14686.1	1	< 0.1%
13184.43	1	< 0.1%
12738.47	1	< 0.1%
12560.85	1	< 0.1%
12541	1	< 0.1%
12375	1	< 0.1%
12235.05	1	< 0.1%
12128.94	1	< 0.1%

CASH_ADVANCE
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4323
Distinct (%)	48.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	978.87111

Minimum	0
Maximum	47137.212
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1113.8211
95-th percentile	4647.1691
Maximum	47137.212
Range	47137.212
Interquartile range (IQR)	1113.8211

Descriptive statistics

Standard deviation	2097.1639
Coefficient of variation (CV)	2.1424311
Kurtosis	52.899434
Mean	978.87111
Median Absolute Deviation (MAD)	0
Skewness	5.1666091
Sum	8760896.5
Variance	4398096.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
495.425832	1	< 0.1%
1486.243293	1	< 0.1%
855.232779	1	< 0.1%
3767.104707	1	< 0.1%
291.608512	1	< 0.1%
38.690552	1	< 0.1%
521.664369	1	< 0.1%
1974.202963	1	< 0.1%
2462.100789	1	< 0.1%
Other values (4313)	4313	48.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4628	51.7%
14.222216	1	< 0.1%
18.042768	1	< 0.1%
18.117967	1	< 0.1%
18.123413	1	< 0.1%
18.126683	1	< 0.1%
18.149946	1	< 0.1%
18.204577	1	< 0.1%
18.240626	1	< 0.1%
18.280043	1	< 0.1%

Value	Count	Frequency (%)
47137.21176	1	< 0.1%
29282.10915	1	< 0.1%
27296.48576	1	< 0.1%
26268.69989	1	< 0.1%
26194.04954	1	< 0.1%
23130.82106	1	< 0.1%
22665.7785	1	< 0.1%
21943.84942	1	< 0.1%
20712.67008	1	< 0.1%
20277.33112	1	< 0.1%

PURCHASES_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.49035055

Minimum	0
Maximum	1
Zeros	2043
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.083333
median	0.5
Q3	0.916667
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.833334

Descriptive statistics

Standard deviation	0.40137075
Coefficient of variation (CV)	0.81853839
Kurtosis	-1.6386309
Mean	0.49035055
Median Absolute Deviation (MAD)	0.416667
Skewness	0.060164236
Sum	4388.6374
Variance	0.16109848
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	2178	24.3%
0	2043	22.8%
0.083333	677	7.6%
0.916667	396	4.4%
0.5	395	4.4%
0.166667	392	4.4%
0.833333	373	4.2%
0.333333	367	4.1%
0.25	345	3.9%
0.583333	316	3.5%
Other values (37)	1468	16.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2043	22.8%
0.083333	677	7.6%
0.090909	43	0.5%
0.1	27	0.3%
0.111111	18	0.2%
0.125	32	0.4%
0.142857	26	0.3%
0.166667	392	4.4%
0.181818	16	0.2%
0.2	19	0.2%

Value	Count	Frequency (%)
1	2178	24.3%
0.916667	396	4.4%
0.909091	28	0.3%
0.9	24	0.3%
0.888889	18	0.2%
0.875	26	0.3%
0.857143	25	0.3%
0.833333	373	4.2%
0.818182	21	0.2%
0.8	9	0.1%

ONEOFF_PURCHASES_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.20245768

Minimum	0
Maximum	1
Zeros	4302
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.083333
Q3	0.3
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.29833607
Coefficient of variation (CV)	1.4735725
Kurtosis	1.1618456
Mean	0.20245768
Median Absolute Deviation (MAD)	0.083333
Skewness	1.5356128
Sum	1811.9963
Variance	0.089004408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.166667	592	6.6%
1	481	5.4%
0.25	418	4.7%
0.333333	355	4.0%
0.416667	244	2.7%
0.5	235	2.6%
0.583333	197	2.2%
0.666667	167	1.9%
Other values (37)	855	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4302	48.1%
0.083333	1104	12.3%
0.090909	56	0.6%
0.1	39	0.4%
0.111111	26	0.3%
0.125	41	0.5%
0.142857	37	0.4%
0.166667	592	6.6%
0.181818	34	0.4%
0.2	27	0.3%

Value	Count	Frequency (%)
1	481	5.4%
0.916667	151	1.7%
0.909091	4	< 0.1%
0.9	1	< 0.1%
0.888889	2	< 0.1%
0.875	6	0.1%
0.857143	1	< 0.1%
0.833333	120	1.3%
0.818182	10	0.1%
0.8	4	< 0.1%

PURCHASES_INSTALLMENTS_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.36443734

Minimum	0
Maximum	1
Zeros	3915
Zeros (%)	43.7%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.166667
Q3	0.75
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.39744778
Coefficient of variation (CV)	1.0905792
Kurtosis	-1.3986322
Mean	0.36443734
Median Absolute Deviation (MAD)	0.166667
Skewness	0.50920116
Sum	3261.7142
Variance	0.15796474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	3915	43.7%
1	1331	14.9%
0.416667	388	4.3%
0.916667	345	3.9%
0.833333	311	3.5%
0.5	310	3.5%
0.166667	305	3.4%
0.666667	292	3.3%
0.75	291	3.3%
0.083333	275	3.1%
Other values (37)	1187	13.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3915	43.7%
0.083333	275	3.1%
0.090909	12	0.1%
0.1	6	0.1%
0.111111	9	0.1%
0.125	5	0.1%
0.142857	6	0.1%
0.166667	305	3.4%
0.181818	14	0.2%
0.2	9	0.1%

Value	Count	Frequency (%)
1	1331	14.9%
0.916667	345	3.9%
0.909091	25	0.3%
0.9	19	0.2%
0.888889	28	0.3%
0.875	28	0.3%
0.857143	30	0.3%
0.833333	311	3.5%
0.818182	21	0.2%
0.8	18	0.2%

CASH_ADVANCE_FREQUENCY
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	54
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1351442

Minimum	0
Maximum	1.5
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.222222
95-th percentile	0.583333
Maximum	1.5
Range	1.5
Interquartile range (IQR)	0.222222

Descriptive statistics

Standard deviation	0.20012139
Coefficient of variation (CV)	1.4807989
Kurtosis	3.3347343
Mean	0.1351442
Median Absolute Deviation (MAD)	0
Skewness	1.8286863
Sum	1209.5406
Variance	0.04004857
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.166667	759	8.5%
0.25	578	6.5%
0.333333	439	4.9%
0.416667	273	3.1%
0.5	215	2.4%
0.583333	142	1.6%
0.666667	125	1.4%
0.090909	70	0.8%
Other values (44)	700	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4628	51.7%
0.083333	1021	11.4%
0.090909	70	0.8%
0.1	39	0.4%
0.111111	29	0.3%
0.125	47	0.5%
0.142857	49	0.5%
0.166667	759	8.5%
0.181818	42	0.5%
0.2	21	0.2%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.25	1	< 0.1%
1.166667	2	< 0.1%
1.142857	1	< 0.1%
1.125	1	< 0.1%
1.1	1	< 0.1%
1.090909	1	< 0.1%
1	25	0.3%
0.916667	27	0.3%
0.909091	3	< 0.1%

CASH_ADVANCE_TRX
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	65
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2488268

Minimum	0
Maximum	123
Zeros	4628
Zeros (%)	51.7%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	123
Range	123
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.8246467
Coefficient of variation (CV)	2.1006496
Kurtosis	61.646862
Mean	3.2488268
Median Absolute Deviation (MAD)	0
Skewness	5.7212982
Sum	29077
Variance	46.575803
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
10	150	1.7%
Other values (55)	915	10.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4628	51.7%
1	887	9.9%
2	620	6.9%
3	436	4.9%
4	384	4.3%
5	308	3.4%
6	246	2.7%
7	205	2.3%
8	171	1.9%
9	111	1.2%

Value	Count	Frequency (%)
123	3	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
93	1	< 0.1%
80	1	< 0.1%
71	1	< 0.1%
69	1	< 0.1%
63	1	< 0.1%
62	3	< 0.1%
61	1	< 0.1%

PURCHASES_TRX
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	173
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.709832

Minimum	0
Maximum	358
Zeros	2044
Zeros (%)	22.8%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	17
95-th percentile	57
Maximum	358
Range	358
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	24.857649
Coefficient of variation (CV)	1.6898662
Kurtosis	34.7931
Mean	14.709832
Median Absolute Deviation (MAD)	7
Skewness	4.6306553
Sum	131653
Variance	617.90272
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
12	570	6.4%
2	379	4.2%
6	352	3.9%
3	314	3.5%
4	285	3.2%
7	275	3.1%
5	267	3.0%
8	267	3.0%
Other values (163)	3530	39.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2044	22.8%
1	667	7.5%
2	379	4.2%
3	314	3.5%
4	285	3.2%
5	267	3.0%
6	352	3.9%
7	275	3.1%
8	267	3.0%
9	248	2.8%

Value	Count	Frequency (%)
358	1	< 0.1%
347	1	< 0.1%
344	1	< 0.1%
309	1	< 0.1%
308	1	< 0.1%
298	1	< 0.1%
274	1	< 0.1%
273	1	< 0.1%
254	1	< 0.1%
248	2	< 0.1%

CREDIT_LIMIT
Real number (ℝ)

Distinct	205
Distinct (%)	2.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	4494.4495

Minimum	50
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	50
5-th percentile	1000
Q1	1600
median	3000
Q3	6500
95-th percentile	12000
Maximum	30000
Range	29950
Interquartile range (IQR)	4900

Descriptive statistics

Standard deviation	3638.8157
Coefficient of variation (CV)	0.80962435
Kurtosis	2.8366559
Mean	4494.4495
Median Absolute Deviation (MAD)	1800
Skewness	1.522464
Sum	40220828
Variance	13240980
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3000	784	8.8%
1500	722	8.1%
1200	621	6.9%
1000	614	6.9%
2500	612	6.8%
4000	506	5.7%
6000	463	5.2%
5000	389	4.3%
2000	371	4.1%
7500	277	3.1%
Other values (195)	3590	40.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50	1	< 0.1%
150	5	0.1%
200	3	< 0.1%
300	14	0.2%
400	3	< 0.1%
450	6	0.1%
500	121	1.4%
600	21	0.2%
650	1	< 0.1%
700	20	0.2%

Value	Count	Frequency (%)
30000	2	< 0.1%
28000	1	< 0.1%
25000	1	< 0.1%
23000	2	< 0.1%
22500	1	< 0.1%
22000	1	< 0.1%
21500	2	< 0.1%
21000	2	< 0.1%
20500	1	< 0.1%
20000	10	0.1%

PAYMENTS
Real number (ℝ)

ZEROS

Distinct	8711
Distinct (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1733.1439

Minimum	0
Maximum	50721.483
Zeros	240
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	89.988924
Q1	383.27617
median	856.90155
Q3	1901.1343
95-th percentile	6082.0906
Maximum	50721.483
Range	50721.483
Interquartile range (IQR)	1517.8582

Descriptive statistics

Standard deviation	2895.0638
Coefficient of variation (CV)	1.6704117
Kurtosis	54.770736
Mean	1733.1439
Median Absolute Deviation (MAD)	581.35146
Skewness	5.9076198
Sum	15511637
Variance	8381394.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	240	2.7%
201.802084	1	< 0.1%
398.316441	1	< 0.1%
826.036748	1	< 0.1%
2571.573214	1	< 0.1%
1903.279643	1	< 0.1%
454.888506	1	< 0.1%
956.028747	1	< 0.1%
4560.77572	1	< 0.1%
1825.349955	1	< 0.1%
Other values (8701)	8701	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	240	2.7%
0.049513	1	< 0.1%
0.056466	1	< 0.1%
2.389583	1	< 0.1%
3.500505	1	< 0.1%
4.523555	1	< 0.1%
4.841543	1	< 0.1%
5.070726	1	< 0.1%
9.040017	1	< 0.1%
9.533313	1	< 0.1%

Value	Count	Frequency (%)
50721.48336	1	< 0.1%
46930.59824	1	< 0.1%
40627.59524	1	< 0.1%
39461.9658	1	< 0.1%
39048.59762	1	< 0.1%
36066.75068	1	< 0.1%
35843.62593	1	< 0.1%
34107.07499	1	< 0.1%
33994.72785	1	< 0.1%
33486.31044	1	< 0.1%

MINIMUM_PAYMENTS
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	8636
Distinct (%)	> 99.9%
Missing	313
Missing (%)	3.5%
Infinite	0
Infinite (%)	0.0%
Mean	864.20654

Minimum	0.019163
Maximum	76406.208
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0.019163
5-th percentile	73.282006
Q1	169.12371
median	312.34395
Q3	825.48546
95-th percentile	2766.5633
Maximum	76406.208
Range	76406.188
Interquartile range (IQR)	656.36175

Descriptive statistics

Standard deviation	2372.4466
Coefficient of variation (CV)	2.745231
Kurtosis	283.98999
Mean	864.20654
Median Absolute Deviation (MAD)	190.3741
Skewness	13.622797
Sum	7464151.9
Variance	5628502.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
299.351881	2	< 0.1%
150.317143	1	< 0.1%
271.528169	1	< 0.1%
6404.855484	1	< 0.1%
616.862544	1	< 0.1%
211.984193	1	< 0.1%
324.954747	1	< 0.1%
1600.26917	1	< 0.1%
277.546713	1	< 0.1%
342.28649	1	< 0.1%
Other values (8626)	8626	96.4%
(Missing)	313	3.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.019163	1	< 0.1%
0.037744	1	< 0.1%
0.05588	1	< 0.1%
0.059481	1	< 0.1%
0.117036	1	< 0.1%
0.261984	1	< 0.1%
0.311953	1	< 0.1%
0.319475	1	< 0.1%
1.113027	1	< 0.1%
1.334075	1	< 0.1%

Value	Count	Frequency (%)
76406.20752	1	< 0.1%
61031.6186	1	< 0.1%
56370.04117	1	< 0.1%
50260.75947	1	< 0.1%
43132.72823	1	< 0.1%
42629.55117	1	< 0.1%
38512.12477	1	< 0.1%
31871.36379	1	< 0.1%
30528.4324	1	< 0.1%
29019.80288	1	< 0.1%

PRC_FULL_PAYMENT
Real number (ℝ)

ZEROS

Distinct	47
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15371465

Minimum	0
Maximum	1
Zeros	5903
Zeros (%)	66.0%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.142857
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0.142857

Descriptive statistics

Standard deviation	0.2924992
Coefficient of variation (CV)	1.9028713
Kurtosis	2.4323953
Mean	0.15371465
Median Absolute Deviation (MAD)	0
Skewness	1.9428199
Sum	1375.7461
Variance	0.08555578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
0	5903	66.0%
1	488	5.5%
0.083333	426	4.8%
0.166667	166	1.9%
0.5	156	1.7%
0.25	156	1.7%
0.090909	153	1.7%
0.333333	134	1.5%
0.1	94	1.1%
0.2	83	0.9%
Other values (37)	1191	13.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5903	66.0%
0.083333	426	4.8%
0.090909	153	1.7%
0.1	94	1.1%
0.111111	61	0.7%
0.125	52	0.6%
0.142857	54	0.6%
0.166667	166	1.9%
0.181818	75	0.8%
0.2	83	0.9%

Value	Count	Frequency (%)
1	488	5.5%
0.916667	77	0.9%
0.909091	19	0.2%
0.9	16	0.2%
0.888889	12	0.1%
0.875	18	0.2%
0.857143	12	0.1%
0.833333	63	0.7%
0.818182	17	0.2%
0.8	33	0.4%

TENURE
Real number (ℝ)

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.517318

Minimum	6
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	70.1 KiB

Quantile statistics

Minimum	6
5-th percentile	8
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.3383308
Coefficient of variation (CV)	0.11620159
Kurtosis	7.6948232
Mean	11.517318
Median Absolute Deviation (MAD)	0
Skewness	-2.9430173
Sum	103080
Variance	1.7911292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
6	204	2.3%
8	196	2.2%
7	190	2.1%
9	175	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	204	2.3%
7	190	2.1%
8	196	2.2%
9	175	2.0%
10	236	2.6%
11	365	4.1%
12	7584	84.7%

Value	Count	Frequency (%)
12	7584	84.7%
11	365	4.1%
10	236	2.6%
9	175	2.0%
8	196	2.2%
7	190	2.1%
6	204	2.3%

Auto

Heatmap
Table

	BALANCE	BALANCE_FREQUENCY	CASH_ADVANCE	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	CREDIT_LIMIT	INSTALLMENTS_PURCHASES	MINIMUM_PAYMENTS	ONEOFF_PURCHASES	ONEOFF_PURCHASES_FREQUENCY	PAYMENTS	PRC_FULL_PAYMENT	PURCHASES	PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	PURCHASES_TRX	TENURE
BALANCE	1.000	0.545	0.566	0.544	0.549	0.372	-0.090	0.900	0.146	0.120	0.432	-0.484	0.006	-0.145	-0.144	-0.046	0.066
BALANCE_FREQUENCY	0.545	1.000	0.137	0.177	0.176	0.106	0.128	0.502	0.135	0.159	0.207	-0.174	0.148	0.202	0.152	0.203	0.229
CASH_ADVANCE	0.566	0.137	1.000	0.941	0.952	0.163	-0.357	0.482	-0.185	-0.189	0.257	-0.266	-0.385	-0.454	-0.378	-0.408	-0.113
CASH_ADVANCE_FREQUENCY	0.544	0.177	0.941	1.000	0.983	0.088	-0.366	0.456	-0.179	-0.176	0.203	-0.287	-0.391	-0.453	-0.382	-0.407	-0.131
CASH_ADVANCE_TRX	0.549	0.176	0.952	0.983	1.000	0.097	-0.357	0.472	-0.175	-0.174	0.215	-0.281	-0.384	-0.447	-0.374	-0.399	-0.099
CREDIT_LIMIT	0.372	0.106	0.163	0.088	0.097	1.000	0.123	0.264	0.305	0.282	0.449	0.021	0.261	0.104	0.047	0.190	0.170
INSTALLMENTS_PURCHASES	-0.090	0.128	-0.357	-0.366	-0.357	0.123	1.000	-0.052	0.200	0.185	0.239	0.276	0.706	0.786	0.923	0.784	0.125
MINIMUM_PAYMENTS	0.900	0.502	0.482	0.456	0.472	0.264	-0.052	1.000	0.070	0.051	0.368	-0.478	-0.008	-0.104	-0.085	-0.025	0.137
ONEOFF_PURCHASES	0.146	0.135	-0.185	-0.179	-0.175	0.305	0.200	0.070	1.000	0.952	0.363	0.049	0.751	0.424	0.117	0.590	0.096
ONEOFF_PURCHASES_FREQUENCY	0.120	0.159	-0.189	-0.176	-0.174	0.282	0.185	0.051	0.952	1.000	0.321	0.061	0.693	0.463	0.112	0.607	0.084
PAYMENTS	0.432	0.207	0.257	0.203	0.215	0.449	0.239	0.368	0.363	0.321	1.000	0.187	0.395	0.172	0.121	0.284	0.205
PRC_FULL_PAYMENT	-0.484	-0.174	-0.266	-0.287	-0.281	0.021	0.276	-0.478	0.049	0.061	0.187	1.000	0.238	0.292	0.259	0.253	0.020
PURCHASES	0.006	0.148	-0.385	-0.391	-0.384	0.261	0.706	-0.008	0.751	0.693	0.395	0.238	1.000	0.795	0.606	0.885	0.133
PURCHASES_FREQUENCY	-0.145	0.202	-0.454	-0.453	-0.447	0.104	0.786	-0.104	0.424	0.463	0.172	0.292	0.795	1.000	0.852	0.924	0.098
PURCHASES_INSTALLMENTS_FREQUENCY	-0.144	0.152	-0.378	-0.382	-0.374	0.047	0.923	-0.085	0.117	0.112	0.121	0.259	0.606	0.852	1.000	0.781	0.114
PURCHASES_TRX	-0.046	0.203	-0.408	-0.407	-0.399	0.190	0.784	-0.025	0.590	0.607	0.284	0.253	0.885	0.924	0.781	1.000	0.169
TENURE	0.066	0.229	-0.113	-0.131	-0.099	0.170	0.125	0.137	0.096	0.084	0.205	0.020	0.133	0.098	0.114	0.169	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	CUST_ID	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	CREDIT_LIMIT	PAYMENTS	MINIMUM_PAYMENTS	PRC_FULL_PAYMENT	TENURE
0	C10001	40.900749	0.818182	95.40	0.00	95.40	0.000000	0.166667	0.000000	0.083333	0.000000	0	2	1000.0	201.802084	139.509787	0.000000	12
1	C10002	3202.467416	0.909091	0.00	0.00	0.00	6442.945483	0.000000	0.000000	0.000000	0.250000	4	0	7000.0	4103.032597	1072.340217	0.222222	12
2	C10003	2495.148862	1.000000	773.17	773.17	0.00	0.000000	1.000000	1.000000	0.000000	0.000000	0	12	7500.0	622.066742	627.284787	0.000000	12
3	C10004	1666.670542	0.636364	1499.00	1499.00	0.00	205.788017	0.083333	0.083333	0.000000	0.083333	1	1	7500.0	0.000000	NaN	0.000000	12
4	C10005	817.714335	1.000000	16.00	16.00	0.00	0.000000	0.083333	0.083333	0.000000	0.000000	0	1	1200.0	678.334763	244.791237	0.000000	12
5	C10006	1809.828751	1.000000	1333.28	0.00	1333.28	0.000000	0.666667	0.000000	0.583333	0.000000	0	8	1800.0	1400.057770	2407.246035	0.000000	12
6	C10007	627.260806	1.000000	7091.01	6402.63	688.38	0.000000	1.000000	1.000000	1.000000	0.000000	0	64	13500.0	6354.314328	198.065894	1.000000	12
7	C10008	1823.652743	1.000000	436.20	0.00	436.20	0.000000	1.000000	0.000000	1.000000	0.000000	0	12	2300.0	679.065082	532.033990	0.000000	12
8	C10009	1014.926473	1.000000	861.49	661.49	200.00	0.000000	0.333333	0.083333	0.250000	0.000000	0	5	7000.0	688.278568	311.963409	0.000000	12
9	C10010	152.225975	0.545455	1281.60	1281.60	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	3	11000.0	1164.770591	100.302262	0.000000	12

	CUST_ID	BALANCE	BALANCE_FREQUENCY	PURCHASES	ONEOFF_PURCHASES	INSTALLMENTS_PURCHASES	CASH_ADVANCE	PURCHASES_FREQUENCY	ONEOFF_PURCHASES_FREQUENCY	PURCHASES_INSTALLMENTS_FREQUENCY	CASH_ADVANCE_FREQUENCY	CASH_ADVANCE_TRX	PURCHASES_TRX	CREDIT_LIMIT	PAYMENTS	MINIMUM_PAYMENTS	PRC_FULL_PAYMENT	TENURE
8940	C19181	130.838554	1.000000	591.24	0.00	591.24	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	475.523262	82.771320	1.00	6
8941	C19182	5967.475270	0.833333	214.55	0.00	214.55	8555.409326	0.833333	0.000000	0.666667	0.666667	13	5	9000.0	966.202912	861.949906	0.00	6
8942	C19183	40.829749	1.000000	113.28	0.00	113.28	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	94.488828	86.283101	0.25	6
8943	C19184	5.871712	0.500000	20.90	20.90	0.00	0.000000	0.166667	0.166667	0.000000	0.000000	0	1	500.0	58.644883	43.473717	0.00	6
8944	C19185	193.571722	0.833333	1012.73	1012.73	0.00	0.000000	0.333333	0.333333	0.000000	0.000000	0	2	4000.0	0.000000	NaN	0.00	6
8945	C19186	28.493517	1.000000	291.12	0.00	291.12	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	325.594462	48.886365	0.50	6
8946	C19187	19.183215	1.000000	300.00	0.00	300.00	0.000000	1.000000	0.000000	0.833333	0.000000	0	6	1000.0	275.861322	NaN	0.00	6
8947	C19188	23.398673	0.833333	144.40	0.00	144.40	0.000000	0.833333	0.000000	0.666667	0.000000	0	5	1000.0	81.270775	82.418369	0.25	6
8948	C19189	13.457564	0.833333	0.00	0.00	0.00	36.558778	0.000000	0.000000	0.000000	0.166667	2	0	500.0	52.549959	55.755628	0.25	6
8949	C19190	372.708075	0.666667	1093.25	1093.25	0.00	127.040008	0.666667	0.666667	0.000000	0.333333	2	23	1200.0	63.165404	88.288956	0.00	6

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample